# 第 0016 题： 纯文本文件 numbers.txt, 里面的内容（包括方括号）如下所示：
from  openpyxl import  Workbook 
import string
import json

def number_excle(numberDate,title,target):
    wb = Workbook()
    ws=wb.active
    ws.title=title
    for i,numbers in enumerate(numberDate):
        for j,v in enumerate(numbers):
            ws[string.ascii_uppercase[j]+str(i+1)]=v
    wb.save(target)



if __name__=='__main__':
    with open('resource/excel/number.txt',encoding='utf-8') as f:
        numberDate=json.load(f)
        print(numberDate)
        number_excle(numberDate,'number','resource/excel/number.xlsx')